package io.renren.modules.pullin.dao;

import io.renren.modules.pullin.entity.BinzhiClassCourse;
import io.renren.modules.pullin.entity.BinzhiStudentInfo;
import io.renren.modules.pullin.entity.BinzhiTeacherInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
@Mapper
public interface PullInDao {
    //拷贝课程信息数据
    @Select("SELECT KCMC,JSZGH,XN,XQ,BJMC,JSXM,XKKH,SKDD,SKSJ" +
            " FROM JXRWB WHERE XN='2017-2018'AND BJMC LIKE '2017%'")
    List<BinzhiClassCourse> CopyTrueClassCourseFO();
    //拷贝学生信息数据
    @Select("SELECT XH,XM,XB,CSRQ,MZ,XY,XZB,ZYMC,XZ,XXNX,XJZT,DQSZJ,RXRQ,LXDH,ZYDM FROM XSJBXXB WHERE XH LIKE '2017%'")
    List<BinzhiStudentInfo> CopyStudentInfoFO();
    //拷贝教师信息数据
    @Select("SELECT ZGH,XM,XB,CSRQ,LXDH,EMLDZ,BM,ZW,ZC,XL,JXYJFX,YXJ,KSFB,ZYMC,BYYX,YWJSZG,RSZGH,SFWP,SFSYSRY,SFZG,ZZMM,MZ,XW,SFFDY,JSXMPY FROM JSXXB")
    List<BinzhiTeacherInfo> CopyTeacherInfoFO();

    @Select("SELECT KCMC,JSZGH,2017-2018,1,BJMC,JSXM,XKKH,SKDD,SKSJ FROM sheet1")
    List<BinzhiClassCourse> CopyTrueClassCourseFO2();
    //临时：拷贝学生信息数据
    @Select("SELECT XH,XM,XB,CSRQ,MZ,XY,XZB,ZYMC,XZ,XXNX,XJZT,DQSZJ,RXRQ,LXDH,ZYDM FROM sheet2")
    List<BinzhiStudentInfo> CopyStudentInfoFO2();
}


